﻿CREATE PROCEDURE [dbo].[proc_MarketProjectItem_Update]
(
	@id int,
	@MID int,
	@T1 int,
	@T3 int,
	@Supplier nvarchar(50),
	@Contact nvarchar(30),
	@Phone nvarchar(30),
	@UnitPrice decimal(18,2),
	@Number int,
	@SpendingTotals decimal(18,2),
	@Person nvarchar(50),
	@Note nvarchar(500),
	@USERID VARCHAR(50),
	@SaveMark INT
)
AS
BEGIN

UPDATE [MarketProjectItem]
   SET 
      [MID] = @MID,
      [T1] = @T1,
      [T3] = @T3,
      [Supplier] = @Supplier,
      [Contact] = @Contact,
      [Phone] = @Phone,
      [UnitPrice] = @UnitPrice,
      [Number] = @Number,
      [SpendingTotals] = @SpendingTotals,
      [Person] = @Person,
      [Note] = @Note,
      [USERID]=@USERID,
      [SaveMark]=@SaveMark
 WHERE [id]=@id


	SET NOCOUNT ON;

END
